SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 53136: The SQL procedure terminates with a segmentation violation when you use a WHEN condition within a CASE expression

DetailsAboutRate It

Using character or numeric constant values in a WHEN condition that is within a CASE expression might cause PROC SQL to terminate with a segmentation violation. This abend occurs if you do not specify an ELSE clause and the WHEN condition subsequently resolves to false.

To work around the issue, include an ELSE clause within the CASE expression. This prevents the abend.



Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemBase SASz/OS9.49.4_M29.4 TS1M09.4 TS1M2
Z649.49.4_M29.4 TS1M09.4 TS1M2
Microsoft® Windows® for x649.49.4_M29.4 TS1M09.4 TS1M2
Microsoft Windows 8 Enterprise x649.49.4_M29.4 TS1M09.4 TS1M2
Microsoft Windows 8 Pro x649.49.4_M29.4 TS1M09.4 TS1M2
Microsoft Windows 8.1 Enterprise 32-bit9.49.4_M29.4 TS1M09.4 TS1M2
Microsoft Windows 8.1 Enterprise x649.49.4_M29.4 TS1M09.4 TS1M2
Microsoft Windows 8.1 Pro9.49.4_M29.4 TS1M09.4 TS1M2
Microsoft Windows 8.1 Pro 32-bit9.49.4_M29.4 TS1M09.4 TS1M2
Microsoft Windows Server 2008 R29.49.4_M29.4 TS1M09.4 TS1M2
Microsoft Windows Server 2008 for x649.49.4_M29.4 TS1M09.4 TS1M2
Microsoft Windows Server 2012 Datacenter9.49.4_M29.4 TS1M09.4 TS1M2
Microsoft Windows Server 2012 R2 Datacenter9.49.4_M29.4 TS1M09.4 TS1M2
Microsoft Windows Server 2012 R2 Std9.49.4_M29.4 TS1M09.4 TS1M2
Microsoft Windows Server 2012 Std9.49.4_M29.4 TS1M09.4 TS1M2
Windows 7 Enterprise x649.49.4_M29.4 TS1M09.4 TS1M2
Windows 7 Professional x649.49.4_M29.4 TS1M09.4 TS1M2
64-bit Enabled AIX9.49.4_M29.4 TS1M09.4 TS1M2
64-bit Enabled HP-UX9.49.4_M29.4 TS1M09.4 TS1M2
64-bit Enabled Solaris9.49.4_M29.4 TS1M09.4 TS1M2
HP-UX IPF9.49.4_M29.4 TS1M09.4 TS1M2
Linux for x649.49.4_M29.4 TS1M09.4 TS1M2
Solaris for x649.49.4_M29.4 TS1M09.4 TS1M2
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.